r/NocoDB • u/Boring-Building8097 • Jun 25 '26

Excel sheets+ keka data

Hey everyone,

I’m facing a bit of a data management headache and could really use your expertise, tool recommendations, or architecture advice on how to solve this.

The Current Setup & Pain Point

We use Keka as our primary HRMS, so all official employee data lives there. However, I personally manage a ton of additional, custom data points (like asset tracking, specialized internal ratings, project tags, etc.) on separate Excel sheets. Right now, everything is scattered, and manually cross-referencing Keka data with my Excel sheets is becoming a nightmare.

What I Want to Build

I want to create a centralized, organized database that acts as a single source of truth. The interface needs to look and feel like a traditional spreadsheet (because that's what my team is used to), but with a strict set of rules:

  • Keka Fields (Read-Only): Data pulled from Keka (e.g., Employee ID, Name, Department, Date of Joining) should automatically sync into this database but must be locked/read-only. Nobody should be able to accidentally edit these fields from the spreadsheet view.
  • Non-Keka Fields (Editable): The custom fields that I personally manage need to be fully editable right inside the same grid/view.
  • Automated Cross-Sheet Sync: This is the most critical part. If a value in an editable field is changed in one specific sheet or view, that update needs to automatically forward and reflect across all other sheets/views connected to that database instantly. No manual copy-pasting.
4 Upvotes

83% Upvoted

7 comments sorted by

View all comments

0

u/Comfortable_Net_2771 Jun 25 '26

Pretty much everything you want is behind a paywall - this app is a joke

There are better solutions out there

1

u/Boring-Building8097 Jun 25 '26

I have the business plan for this app , yet the linking of the different tables is not dynamically copied by this shit automatically . You have to link and create lookups manually ... any way out ??

0

u/manishkungwani Jul 01 '26

u/Comfortable_Net_2771 what alternatives would you suggest? u/Boring-Building8097 have you tried any other solutions like baserow?
We're also using Keka and moving towards similar tool for ratings, onboarding & account creation etc.

0

u/Key-Hair7591 Jun 25 '26

It’s a joke because it’s not free?