4 ms·

Show HN: Easily convert spreadsheets into accessible URL endpoints

13 points by hilem 11y ago

osullivj 11y ago
What Excel formats do you support? I tried a simple Excel 97-2003 .xls, with no VBA or addins, and got some kind of format error.
- hilem 11y ago
  Just csv at the moment. Let me know if you still have an issue if you export to csv and try again!
  - teh_klev 11y ago
    With regards to Excel, many "in the wild" Excel workbooks will contain multiple worksheets, so it's not really practical to export a CSV for each one. Would be worth considering doing this well and supporting workbooks with multiple worksheets (same applies to Libre Office as well). Can I also suggest you let folks play around without having to create an account (I abandoned at that point so haven't been able to play around), or at least provide a demo account that mops up stuff older than 24 hours.
    - osullivj 11y ago
      Many in the wild Excel workbooks will contain formulae as well. You can't export those to a CSV.
      - teh_klev 11y ago
        Oh sure, I was just talking about workbooks containing multiple sheets with static data.
    - hilem 11y ago
      Thanks for the feedback! Excel with multiple worksheets is on the roadmap. Wanted to get the leanest solution out first to better gauge interest. There is a link to a live API on the homepage, and a playground on the API's page which you can use by hitting "Free Token" up top. The copy and placement of those buttons needs to be cleaned up to be conveyed better.
Tomino 11y ago
I see what you did there, but do not really see what is it good for ? It is only static data right ? Check out this: https://ipushpull.com https://ipushpull.com where you can create true live data out of your excel files. I think some examples on your website would help people to understand better...
- hilem 11y ago
  Hadn't seen ipushpull. Thanks! You're right about the examples. The one differentiator which isn't out yet will be the stripe integration, allowing people to profit off their data.
koesterd 11y ago
There is no content in the HTML title tag on https://www.apicastor.com/ https://www.apicastor.com/

13 points by hilem 11y ago

What Excel formats do you support? I tried a simple Excel 97-2003 .xls, with no VBA or addins, and got some kind of format error.

hilem 11y ago
Just csv at the moment. Let me know if you still have an issue if you export to csv and try again!
- teh_klev 11y ago
  With regards to Excel, many "in the wild" Excel workbooks will contain multiple worksheets, so it's not really practical to export a CSV for each one. Would be worth considering doing this well and supporting workbooks with multiple worksheets (same applies to Libre Office as well). Can I also suggest you let folks play around without having to create an account (I abandoned at that point so haven't been able to play around), or at least provide a demo account that mops up stuff older than 24 hours.
  - osullivj 11y ago
    Many in the wild Excel workbooks will contain formulae as well. You can't export those to a CSV.
    - teh_klev 11y ago
      Oh sure, I was just talking about workbooks containing multiple sheets with static data.
  - hilem 11y ago
    Thanks for the feedback! Excel with multiple worksheets is on the roadmap. Wanted to get the leanest solution out first to better gauge interest. There is a link to a live API on the homepage, and a playground on the API's page which you can use by hitting "Free Token" up top. The copy and placement of those buttons needs to be cleaned up to be conveyed better.

Tomino 11y ago

I see what you did there, but do not really see what is it good for ? It is only static data right ? Check out this: https://ipushpull.com https://ipushpull.com where you can create true live data out of your excel files. I think some examples on your website would help people to understand better...

hilem 11y ago
Hadn't seen ipushpull. Thanks! You're right about the examples. The one differentiator which isn't out yet will be the stripe integration, allowing people to profit off their data.

koesterd 11y ago

There is no content in the HTML title tag on https://www.apicastor.com/ https://www.apicastor.com/