How to import a CSV into Firestore without writing scripts

The traditional pain

Out of the box, Firestore has no CSV import. Teams typically write a small Node script with firebase-admin, parse rows with a library like csv-parse, and call set() in a loop. It works, but it is one-off code that nobody wants to maintain, and only developers can run it.

The FireSheets import wizard

Open the target collection in FireSheets and click Import. The wizard walks you through three steps: upload the CSV file, map columns to Firestore fields and choose how document IDs are generated (auto, from a column or by a template), then preview the first rows exactly as they will be written.

Tips for clean imports

Normalise dates to ISO 8601 before importing so Firestore stores them as timestamps. Use a unique column for document IDs when you plan to re-import the same dataset, that turns the import into an upsert. Keep a separate import file per collection so subcollections stay tidy.

What you get back

Every import is logged with row counts and any errors, so you can re-run a failed import on a smaller slice. Combined with the matching CSV export feature, FireSheets turns Firestore into something your operations and content teams can actually work with.