Connect a spreadsheet
Your invoices, in a spreadsheet that fills itself in
Most document tools hand you a file to download. That is fine once, and a chore every week after. Datanem gives each database a link that always returns it as it stands, so the spreadsheet or dashboard you already use can fetch it on a schedule and nobody has to remember.
=IMPORTDATA("https://datanem.com/feed/YOUR-LINK.csv")- Open a blank sheet and click cell A1.
- Paste the formula above and press enter.
- The whole database fills in below it.
Sheets re-reads an IMPORTDATA link about every hour on its own.
Replace the placeholder with your own link, which you make on the database page under Connect a spreadsheet.
What comes down the link
Every batch you have run against that database, unioned into one table, built against the columns as they stand today. Rows extracted before a column existed are simply blank in it. Upload another stack tomorrow and the same link returns those too, with no change at the other end.
Keeping it safe
The link carries its own key, which is what lets a spreadsheet read it without performing a sign-in. That also means anyone holding it can read that database, so it is worth treating like a password. You can replace it or switch it off at any time, and the old one stops working at once. We store only a hash of it, so it cannot be read back off our side, which is why it is shown to you once.
If you would rather have a file
Every database also exports as Excel, CSV or a SQL dump, and for anything being fed to code, as JSON, JSONL or a ready-made pandas loader that already knows which columns are dates and which are numbers.
No card. Sign up and the first 20 documents are on us.