Breaking News: Grepper is joining You.com. Read the official announcement!

How to export Firebase database to Excel

YOU.com answered on September 11, 2023 Popularity 5/10 Helpfulness 1/10

answer How to export Firebase database to Excel

How to export Firebase database to Excel

Comment

const admin = require('firebase-admin');
const fs = require('fs');
const XLSX = require('xlsx');

// Initialize the Firebase Admin SDK
// Replace the serviceAccountKey.json with your own credentials
admin.initializeApp({
  credential: admin.credential.cert(serviceAccountKey),
  databaseURL: 'https://YOUR_PROJECT_ID.firebaseio.com'
});

// Get the data from Firebase database
const dbRef = admin.database().ref('/path/to/database');
dbRef.once('value')
  .then((snapshot) => {
    const data = snapshot.val();

    // Convert data to Excel format
    const workbook = XLSX.utils.book_new();
    const worksheet = XLSX.utils.json_to_sheet(data);
    XLSX.utils.book_append_sheet(workbook, worksheet, 'Data');

    // Save the workbook to a file
    const excelFilePath = '/path/to/save/excel/file.xlsx';
    XLSX.writeFile(workbook, excelFilePath);

    console.log('Firebase database exported to Excel successfully.');
  })
  .catch((error) => {
    console.error('Error exporting Firebase database to Excel:', error);
  });

Popularity 5/10 Helpfulness 1/10 Language javascript

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 11 2023

YOU.com

0 Answers Avg Quality 2/10

How to export Firebase database to Excel

Contents

More Related Answers

How to export Firebase database to Excel

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.